[dbo].[BAEOrderProductCategoryLookupDelete]
SQLServer
>
iMIS1521GA
>
Stored Procedures
> dbo.BAEOrderProductCategoryLookupDelete
Properties
Parameters
SQL Script
Uses
Properties
Property
Value
ANSI Nulls On
Quoted Identifier On
Parameters
Name
Data Type
Max Length (Bytes)
@OrderProductID
int
4
@OrderCategoryID
int
4
SQL Script
create
procedure
[dbo]
.
[BAEOrderProductCategoryLookupDelete]
@OrderProductID
as
int
,
@OrderCategoryID
AS
int
AS
DELETE
FROM
OrderProductCategoryLookup
WHERE
OrderProductID
=
@OrderProductID
AND
OrderCategoryID
=
@OrderCategoryID
;
GO
Uses
[dbo].[OrderProductCategoryLookup]
dbo